﻿using NPOI.SS.Formula.Functions;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Models
{
    /// <summary>
    /// 客户表
    /// </summary>
    public class ClientDTO
    {
        /// <summary>
        /// 主键
        /// </summary>
        public int? Id { get; set; }

        /// <summary>
        /// 客户id
        /// </summary>
        public string? ClientId { get; set; }

        /// <summary>
        /// 客户id
        /// </summary>
        public int? ClientIdd { get; set; }

        /// <summary>
        /// 客户名称
        /// </summary>
        public string? ClientName { get; set; }


        /// <summary>
        /// 手机
        /// </summary>
        public string? Phone { get; set; }

        /// <summary>
        /// 类型Id
        /// </summary>
        public int? ClientTypeId { get; set; }
        /// <summary>
        /// 类型名称
        /// </summary>
        public string? TypeName { get; set; }


        /// <summary>
        /// 身份证号
        /// </summary>
        public string? IdNumber { get; set; }


        /// <summary>
        /// 风险等级Id
        /// </summary>
        public int? RankId { get; set; }
        /// <summary>
        /// 客户进度
        /// </summary>
        public int? Progress { get; set; }




        /// <summary>
        /// 历史契约数
        /// </summary>
        public int? NumberofContracts { get; set; }


        /// <summary>
        /// 累计逾期次数
        /// </summary>
        public int? NumberofOverdues { get; set; }
        /// <summary>
        /// 是否逾期
        /// </summary>
        public string? Isoverdueid { get; set; }


        /// <summary>
        /// 渠道来源
        /// </summary>
        public string? ChannelSource { get; set; }

        /// <summary>
        /// 性别
        /// </summary>
        public string? Sex { get; set; }

        /// <summary>
        /// 婚姻状况
        /// </summary>
        public string? Marriage { get; set; }

        /// <summary>
        /// 居住地址
        /// </summary>
        public string? ResidentialAddress { get; set; }

        /// <summary>
        /// 工作单位
        /// </summary>
        public string? Workplace { get; set; }
        /// <summary>
        /// 部门
        /// </summary>
        public string? Department { get; set; }

        /// <summary>
        /// 驾龄情况（年）
        /// </summary>
        public string? DrivingAge { get; set; }

        /// <summary>
        /// 居住时间
        /// </summary>
        public string? LengthOfStay { get; set; }

        /// <summary>
        /// 工作时间
        /// </summary>
        public string? workingHours { get; set; }

        /// <summary>
        /// 职位
        /// </summary>
        public string? Posts { get; set; }

        /// <summary>
        /// 社交id
        /// </summary>
        public int? SocialID { get; set; }


        /// <summary>
        /// 累计逾期次数
        /// </summary>
        public string? NumberofOverduesName { get; set; }
        /// <summary>
        /// 历史契约数
        /// </summary>
        public string? NumberofContractsNamer { get; set; }


        /// <summary>
        /// 起租日期
        /// </summary>
        public DateTime? RentStartTime { get; set; }








        /// <summary>
        /// 家庭成员
        /// </summary>
        public string? FamilyMembers { get; set; }


        /// <summary>
        /// 关系
        /// </summary>
        public string? Relationship { get; set; }

        /// <summary>
        ///月收入
        /// </summary>
        public string? MonthlyIncome { get; set; }

        /// <summary>
        ///子女情况
        /// </summary>
        public string? Children { get; set; }

        /// <summary>
        ///紧急联系人
        /// </summary>
        public string? Urgent { get; set; }

        /// <summary>
        ///联系方式
        /// </summary>
        public string? SContact { get; set; }

        /// <summary>
        ///身份证号码
        /// </summary>
        public string? Sidentitycard { get; set; }

        /// <summary>
        ///工作职务
        /// </summary>
        public string? JobTitle { get; set; }

        /// <summary>
        ///是否担保
        /// </summary>
        public string? Guarantee { get; set; }

        /// <summary>
        ///关系表
        /// </summary>
        public int? RelationshipID { get; set; }


        /// <summary>
        ///家庭其他收入
        /// </summary>
        public decimal? OtherIncome { get; set; }

        /// <summary>
        ///房屋类型
        /// </summary>
        public string? TypeOfHouse { get; set; }

        /// <summary>
        ///其他描述
        /// </summary>
        public string? Description { get; set; }



        /// <summary>
        /// 总数据条数
        /// </summary>
        public int Count { get; set; }






    }
}
